
use common
go

if exists (select 1 from sysobjects where name = "p_GetSupplierName")
begin
        drop proc p_GetSupplierName
end
go
 
create proc p_GetSupplierName
as
begin
select * from t_Supplier 
end
go

grant all on p_GetSupplierName to public
go

sp_procxmode "common..p_GetSupplierName","anymode"
go

